﻿CREATE TABLE [dbo].[ModificationHistory] (
    [ID]               INT           IDENTITY (1, 1) NOT NULL,
    [Name]             VARCHAR (50)  NOT NULL,
    [ActionDate]       DATETIME      NOT NULL,
    [ModifiedByUserID] INT           NOT NULL,
    [Action]           INT           NOT NULL,
    [EntityType]       INT           NOT NULL,
    [EntityID]         INT           NULL,
    [SiteID]           INT           NULL,
    [Details]          VARCHAR (MAX) NULL
);

